Tabela PhReservationLimit

Definicja tabeli PhReservationLimit

Name

PhReservationLimit

Code

PhReservationLimit

Comment

Zdefiniowane limity rezerwacji


Lista kolumn tabeli PhReservationLimit

Name

Code

ReservationLimitID

ReservationLimitID

Limit

Limit

StartDT

StartDT

EndDT

EndDT

DeliveryStockID

DeliveryStockID

LimitedStockID

LimitedStockID

StockItemID

StockItemID

UserID

UserID


Kolumna ReservationLimitID tabeli PhReservationLimit

Definicja kolumny ReservationLimitID tabeli PhReservationLimit

Name

ReservationLimitID

Code

ReservationLimitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Limit tabeli PhReservationLimit

Definicja kolumny Limit tabeli PhReservationLimit

Name

Limit

Code

Limit

Data Type

NUMBER(10)

Mandatory

Yes

Comment

wartosc limitu procentowo


Kolumna StartDT tabeli PhReservationLimit

Definicja kolumny StartDT tabeli PhReservationLimit

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

data poczatkowa limitu rezerwacji


Kolumna EndDT tabeli PhReservationLimit

Definicja kolumny EndDT tabeli PhReservationLimit

Name

EndDT

Code

EndDT

Data Type

DATE

Mandatory

No

Comment

data konca limitu rezerwacji


Kolumna DeliveryStockID tabeli PhReservationLimit

Definicja kolumny DeliveryStockID tabeli PhReservationLimit

Name

DeliveryStockID

Code

DeliveryStockID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

magazyn na którym zarezerwowano pozycje
alter table PhReservationLimit
add constraint FK_PHRESERV_R_2347_PHST foreign key (DeliveryStockID)
references PhSt (StID)


Kolumna LimitedStockID tabeli PhReservationLimit

Definicja kolumny LimitedStockID tabeli PhReservationLimit

Name

LimitedStockID

Code

LimitedStockID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

alter table PhReservationLimit
add constraint FK_PHRESERV_R_2348_PHST foreign key (LimitedStockID)
references PhSt (StID)


Kolumna StockItemID tabeli PhReservationLimit

Definicja kolumny StockItemID tabeli PhReservationLimit

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id pozycji asortymentu na która zalozony jest limit rezerwacji
alter table PhReservationLimit
add constraint FK_PHRESERV_R_2346_PHSTITEM foreign key (StockItemID)
references PhStItem (StItemID)


Kolumna UserID tabeli PhReservationLimit

Definicja kolumny UserID tabeli PhReservationLimit

Name

UserID

Code

UserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli PhReservationLimit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhReservationLimit

Definicja klucza Identifier_1 tabeli PhReservationLimit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment